Set up order acknowledgements to send via email
This example explains how to set up the SOP Order Acknowledgement (Single) layout so that you can email your acknowledgements to preferred customer contacts.
This example explains how to:
- Set up the SOP Order Acknowledgement (Single) layout so that you can automatically email order acknowledgements to customers.
- Choose which customer contact you want to send the email to. Order acknowledgements are sent to the customer contact that is marked as the preferred contact for the Account Role.
- Send copies of your order acknowledgement to other recipients.
- Send the order acknowledgements as email attachments.
- Send email messages to your Outbox first for checking.
Set up your order acknowledgement layout in Report Designer
Open: Tools > Run Sage Report Designer.
-
Select your SOP order acknowledgement layout: File Explorer > Layouts.
- From the Properties pane, select Email options and click .
-
Enter your email options:
-
From the Email message should contain: drop-down list, choose the group that matches the header section of the order acknowledgement layout.
For the SOP Order Acknowledgement (Single) layout, select the group that contains the SOPOrderReturntID. This can be Group 5 or 6 as these are both headers for the order acknowledgement.
-
Click To.... and add the required recipients. To send your SOP order acknowledgement to the Account contact for each customer add the SL Customer Accounts > ContactEmailAddress expression.
See how to add this expression-
In the Expressions section, click Add.
-
Drag the following from the Fields pane to the Expression Editor section:
SL Customer Accounts > ContactEmailAddress.
- Click OK.
Alternatively, you can copy and paste the following expression:
CopySLCustomerAccounts.ContactEmailAddress
-
-
If required, click CC... to enter the recipients for a copy of the email.
These can be entered as text or as an expression.
-
Enter a Subject for the email:
This can be entered as text or you can use an expression to include information such as your company name and the order acknowledgement number.
See how to add this expression-
Click Subject.
-
Drag the following from the Fields Pane:
SYSCompanies > CompanyName.
-
In the Expression Editor, enter + " Order Acknowledgement No: " +
Note: To add more than one expression use + or and. If you want to include text with an expression use "quotation marks" around the text.
-
Drag the following from the Fields pane:
SOPInvoiceCredits > DocumentNo.
The completed expression should be as follows:
SYSCompanies.CompanyName + " Order Acknowledgement No: " + SOPOrderReturns.DocumentNo
. - Click OK.
Alternatively, you can copy and paste the following expression:
CopySYSCompanies.CompanyName + " Order Acknowledgement No: " + SOPOrderReturns.DocumentNo
-
-
Choose whether to send the report as plain text or as an attachment.
See how to send as plain textIf you want to send the report as plain text, you may have to amend the layout to make it suitable for an email message, as the layout is designed for printed output.
Note: Some layouts contain text that is designed to be read by a 3rd party document management add on available for Sage 200. This text is not designed to be printed but will appear when the document is sent as plain text. You may want remove this if you are sending your emails as plain text.
See how to send as an attachment- Enter the required message text.
- Choose the file type that you want to send from the Attachment Format drop-down list.
-
Enter a Filename for the attachment.
You can use an expression for this if you want the filename to include information such as your company name and the order acknowledgement number.
See how to add this expression-
Click Filename.
-
Drag the following from the Fields Pane:
SYSCompanies > CompanyName.
- In the Expression Editor, enter + "Invoice No:" +
-
Drag the following from the Fields pane:
SOPInvoiceCredits > DocumentNo.
The completed expression should be as follows:
SYSCompanies.CompanyName + " Order Acknowledgement No: " + SOPOrderReturns.DocumentNo
. - Click OK.
Alternatively, you can copy and paste the following expression:
CopySYSCompanies.CompanyName + " Order Acknowledgement No: " + SOPOrderReturns.DocumentNo
-
- Choose whether to send the order acknowledgements via email straight away or to your outbox for checking before sending to email recipients.
-
Choose your email account provider.
Microsoft Outlook Select this if you are using Microsoft Outlook MAPI Select this if your email application uses a MAPI (Outlook / Exchange) mail server. -
To save the new acknowledgement layout, select File > Save As.
When you change a default layout, letter or report, you must save the new layout, letter or report in the custom or company folder.
Set up your customer account contacts
-
Choose to use the new order acknowledgement layout.
-
Set up a Preferred Contact for the Account role with a valid email address for each customer account that you want to send order acknowledgements by email.
See how to set up a preferred contactOpen: Sales Ledger > Sales Accounts > Amend Account Details | Contacts.
- Select the contact and click Edit.
- Add or edit the Account role and select Preferred Contact.